Forensic Investigation in SQL Server Database Using Temporal Tables & Extended Events Artifacts
نویسندگان
چکیده
Different Database management systems (DBMS) were developed and introduced to store manipulate data. Microsoft SQL (MSSQL) Server one of the most popular relational DBMS used for large databases. With increasing use databases, intentional unintentional accidents on databases are dramatically. Therefore, there is a great need develop database forensic investigation (DBFI) tools models. The temporal table new feature with MSSQL server 2012 track changes, audit, data loss protection, recovery. In addition, extended events another 2008 performance troubleshooting. This study focused DBFI in using tables artifacts. experiment conducted results have presented artifacts analyzing determining internal unauthorized modification database.
منابع مشابه
Implementing SD - SQL Server : a Scalable Distributed Database System ( Extended
SD-SQL Server is a scalable distributed DBS using internally the SQL Server. The relational tables of SD-SQL Server scale through splits transparently for the application. SD-SQL Server is the only DBS with this capability at present. It constitutes an important step beyond the current technology of a parallel DBMS, long awaited by the users. The splitting and addressing principles of our syste...
متن کاملTemporal Query Processig Using Sql Server
Most data sources in real-life are not static but change their information in time. This evolution of data in time can give valuable insights to business analysts. Temporal data refers to data, where changes over time or temporal aspects play a central role. Temporal data denotes the evaluation of object characteristics over time. One of the main unresolved problems that arise during the data m...
متن کاملSD-SQL Server: Scalable Distributed Database System
We present SD-SQL Server, a prototype scalable distributed database system. It let a relational table to grow over new storage nodes invisibly to the application. The evolution uses splits dynamically generating a distributed range partitioning of the table. The splits avoid the reorganization of a growing database, necessary for the current DBMSs and a headache for the administrators. We illus...
متن کاملExtended SQL Aggregation for Database Transformation
To prepare a normalized data set from relational database for analysis requires significant efforts and it is time consuming task. The main reason is that, in general the database grows with many tables and views that must be joined, aggregated and transformed in order to build the required data set. As result, most of the SQL queries are written independently multiple times and in disorganize ...
متن کاملA Novel Approach for Monitoring SQL Anti-Forensic Attacks Using Pattern Matching for Digital Forensic Investigation
Over the past few years the attacks on Software systems is increasing at an astonishing rate resulting in high revenue losses. Hence, Cyber/Digital forensics plays an important role by providing methods to acquire, asses, interpret, and use digital evidence to fetch conclusive details of cyber crime behavior. Recent trend in cyber crimes is the use of Anti-Forensic attacks to thwart the process...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: International Journal of Applied Sciences and Smart Technologies
سال: 2023
ISSN: ['2655-8564', '2685-9432']
DOI: https://doi.org/10.24071/ijasst.v5i1.4611